<?php
$table = $this->adapter->getConfig()->table;
$vars = $this->getVars();

unset($vars['adapter']);
unset($vars['id']);
unset($vars['execmethod']);
unset($vars['cmdfile']);
unset($vars['cmd']);

foreach($vars as $name => $value) {
	if ($name == 'password') {
		$vars[$name] = "\t`" . $table . "`.`" . $name . "` = SHA1(CONCAT('" . $value . "', self.salt))";

		continue;
	}
	
	$vars[$name] = "\t`" . $table . "`.`" . $name . "` = '" . $value . "'";
}
?>


INSERT INTO
	<?php echo $table; ?>

SET

<?php echo implode(",\n", $vars); ?>